<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/shinyv2062/article/details/51261132"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"mysql杀死堵塞进程 - shinyv2062的博客"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>mysql杀死堵塞进程 - shinyv2062的博客 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
        <script type="text/javascript">
        var username = "shinyv2062";
        var blog_address = "https://blog.csdn.net/shinyv2062";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/shinyv2062/article/details/51261132"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin3-template";
        // 收藏所需数据
        var articleTitle = "mysql杀死堵塞进程";
        var articleDesc = "前段时间一个项目的mysql进程发生堵塞，导致load很高，甚至导致mysql连接web层失败。解决的方法有两种方法，一个是：杀进程，另一个方法是重启mysql。经过考虑，应为堵塞，有风险导致mysql重启会起不来，决定使用杀进程这种方法。这个方法也是有一定的问题。应为有进程完成，有进程未完成，所以导致无法批量删除，只能手动删除，如果堵塞的进程很多，会很烦。查看进程：mysql>sh";
        // 第四范式所需数据
        var articleTitles = "mysql杀死堵塞进程 - shinyv2062的博客";
        
        var nickName = "shinyv2062";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/shinyv2062/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/shinyv2062/article/details/51261132";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-923","con":",,"}' data-track-click='{"mod":"kp_popu_476-923","con":",,"}' data-report-view='{"mod":"kp_popu_476-923","keyword":""}' data-report-click='{"mod":"kp_popu_476-923","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1564384140363.png',bigMoveImg:'https://img-bss.csdn.net/1564384127097.png',link:'https://kunyu.csdn.net?p=476&a=923&c=437&k=&d=1&t=3&dest=https%3A%2F%2Fedu.csdn.net%2Ftopic%2Fai30%3Futm_source%3Dblogpopup',trackSuperId:476,smallMove:'notMove',trackSId:923});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">mysql杀死堵塞进程</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2016年04月27日 14:48:10</span>
                    <a class="follow-nickName" href="https://me.csdn.net/shinyv2062" target="_blank">shinyv2062</a>
                    <span class="read-count">阅读数 14989</span>
                                                                                                                                </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                                <div class="article-copyright">
                        
                        版权声明：本文为博主原创文章，未经博主允许不得转载。                        <a class="copy-right-url" href=" https://blog.csdn.net/shinyv2062/article/details/51261132"> https://blog.csdn.net/shinyv2062/article/details/51261132</a>
                    </div>
                                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <div id="content_views" class="markdown_views prism-atom-one-dark">
                    <!-- flowchart 箭头图标 勿删 -->
                    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
                        <path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"></path>
                    </svg>
                                            <p>前段时间一个项目的mysql进程发生堵塞，导致load很高，甚至导致mysql连接web层失败。解决的方法有两种方法，一个是：杀进程，另一个方法是重启mysql。经过考虑，应为堵塞，有风险导致mysql重启会起不来，决定使用杀进程这种方法。 <br>
    这个方法也是有一定的问题。应为有进程完成，有进程未完成，所以导致无法批量删除，只能手动删除，如果堵塞的进程很多，会很烦。</p>

<pre><code>查看进程：
</code></pre>

<pre class="prettyprint"><code class=" hljs smalltalk">mysql&gt; show processlist;
+---------+------+--------------------+--------------+---------+------+-------+------------------+
| <span class="hljs-class">Id</span>      | <span class="hljs-class">User</span> | <span class="hljs-class">Host</span>               <span class="hljs-localvars">| db           |</span> <span class="hljs-class">Command</span> | <span class="hljs-class">Time</span> | <span class="hljs-class">State</span> | <span class="hljs-class">Info</span>             |
+---------+------+--------------------+--------------+---------+------+-------+------------------+
| <span class="hljs-number">1628036</span> <span class="hljs-localvars">| root |</span> <span class="hljs-number">172.17</span><span class="hljs-number">.63</span><span class="hljs-number">.19</span>:<span class="hljs-number">45336</span> <span class="hljs-localvars">| xdf_wechat   |</span> <span class="hljs-class">Sleep</span>   |   <span class="hljs-number">16</span> |       | <span class="hljs-class">NULL</span>             |
| <span class="hljs-number">1628166</span> <span class="hljs-localvars">| root |</span> <span class="hljs-number">172.17</span><span class="hljs-number">.63</span><span class="hljs-number">.19</span>:<span class="hljs-number">45348</span> <span class="hljs-localvars">| xdf_wechat   |</span> <span class="hljs-class">Sleep</span>   |   <span class="hljs-number">20</span> |       | <span class="hljs-class">NULL</span>             |
| <span class="hljs-number">1628962</span> <span class="hljs-localvars">| root |</span> <span class="hljs-number">172.17</span><span class="hljs-number">.63</span><span class="hljs-number">.19</span>:<span class="hljs-number">45471</span> <span class="hljs-localvars">| xdf_platform |</span> <span class="hljs-class">Sleep</span>   |   <span class="hljs-number">20</span> |       | <span class="hljs-class">NULL</span>             |
| <span class="hljs-number">1629587</span> <span class="hljs-localvars">| root |</span> <span class="hljs-number">172.17</span><span class="hljs-number">.63</span><span class="hljs-number">.19</span>:<span class="hljs-number">45855</span> <span class="hljs-localvars">| xdf_platform |</span> <span class="hljs-class">Sleep</span>   |   <span class="hljs-number">20</span> |       | <span class="hljs-class">NULL</span>             |
| <span class="hljs-number">1629693</span> <span class="hljs-localvars">| root |</span> <span class="hljs-number">172.17</span><span class="hljs-number">.63</span><span class="hljs-number">.19</span>:<span class="hljs-number">46018</span> <span class="hljs-localvars">| xdf_wechat   |</span> <span class="hljs-class">Sleep</span>   |    <span class="hljs-number">8</span> |       | <span class="hljs-class">NULL</span>             |
| <span class="hljs-number">1629721</span> <span class="hljs-localvars">| root |</span> <span class="hljs-number">172.17</span><span class="hljs-number">.63</span><span class="hljs-number">.19</span>:<span class="hljs-number">46071</span> <span class="hljs-localvars">| xdf_wechat   |</span> <span class="hljs-class">Sleep</span>   |   <span class="hljs-number">17</span> |       | <span class="hljs-class">NULL</span>             |
| <span class="hljs-number">1629901</span> <span class="hljs-localvars">| root |</span> <span class="hljs-number">172.17</span><span class="hljs-number">.63</span><span class="hljs-number">.19</span>:<span class="hljs-number">46330</span> <span class="hljs-localvars">| xdf_wechat   |</span> <span class="hljs-class">Sleep</span>   |   <span class="hljs-number">18</span> |       | <span class="hljs-class">NULL</span>             |
| <span class="hljs-number">1629902</span> <span class="hljs-localvars">| root |</span> <span class="hljs-number">172.17</span><span class="hljs-number">.63</span><span class="hljs-number">.19</span>:<span class="hljs-number">46332</span> <span class="hljs-localvars">| xdf_wechat   |</span> <span class="hljs-class">Sleep</span>   |   <span class="hljs-number">18</span> |       | <span class="hljs-class">NULL</span>             |
| <span class="hljs-number">1631017</span> <span class="hljs-localvars">| root |</span> <span class="hljs-number">172.17</span><span class="hljs-number">.63</span><span class="hljs-number">.19</span>:<span class="hljs-number">47559</span> <span class="hljs-localvars">| xdf_wechat   |</span> <span class="hljs-class">Sleep</span>   |   <span class="hljs-number">18</span> |       | <span class="hljs-class">NULL</span>             |
| <span class="hljs-number">1631094</span> <span class="hljs-localvars">| root |</span> <span class="hljs-number">172.17</span><span class="hljs-number">.63</span><span class="hljs-number">.19</span>:<span class="hljs-number">47645</span> <span class="hljs-localvars">| xdf_wechat   |</span> <span class="hljs-class">Sleep</span>   |    <span class="hljs-number">0</span> |       | <span class="hljs-class">NULL</span>             |
| <span class="hljs-number">1631095</span> <span class="hljs-localvars">| root |</span> <span class="hljs-number">172.17</span><span class="hljs-number">.63</span><span class="hljs-number">.19</span>:<span class="hljs-number">47646</span> <span class="hljs-localvars">| xdf_wechat   |</span> <span class="hljs-class">Sleep</span>   |   <span class="hljs-number">19</span> |       | <span class="hljs-class">NULL</span>             |
| <span class="hljs-number">1631097</span> <span class="hljs-localvars">| root |</span> <span class="hljs-number">172.17</span><span class="hljs-number">.63</span><span class="hljs-number">.19</span>:<span class="hljs-number">47647</span> <span class="hljs-localvars">| xdf_wechat   |</span> <span class="hljs-class">Sleep</span>   |   <span class="hljs-number">10</span> |       | <span class="hljs-class">NULL</span>             |
| <span class="hljs-number">1631254</span> <span class="hljs-localvars">| root | localhost          |</span> <span class="hljs-class">NULL</span>         | <span class="hljs-class">Query</span>   |    <span class="hljs-number">0</span> | <span class="hljs-class">NULL</span>  <span class="hljs-localvars">| show processlist |</span>
+---------+------+--------------------+--------------+---------+------+-------+------------------+
<span class="hljs-number">13</span> rows in set (<span class="hljs-number">0.00</span> sec)
</code></pre>

<p>手动杀</p>



<pre class="prettyprint"><code class=" hljs livecodeserver"><span class="hljs-built_in">kill</span> ID；</code></pre>

<p>解决问题。</p>                                    </div>
                <link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-e44c3c0e64.css" rel="stylesheet">
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/shinyv2062/article/details/51261132","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/shinyv2062/article/details/51261132","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-402","con":",,"}' data-track-click='{"mod":"kp_popu_58-402","con":",,"}' data-report-view='{"mod":"kp_popu_58-402","keyword":""}' data-report-click='{"mod":"kp_popu_58-402","keyword":""}'><div style="width:100%;background:#fff;border:3px solid #fff;padding:16px 0px 0px 0px;">
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<div id="three_ad1" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 100,
                showid : 'ztvJV8',
                placeholderId: "three_ad1",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 0,
                    imageWidth: 90,
                    imageHeight: 68,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft YaHei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 20,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="51261132">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u012129607/article/details/78851920","strategy":"BlogCommendFromAutoMl2","index":"0"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u012129607/article/details/78851920","strategy":"BlogCommendFromAutoMl2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012129607/article/details/78851920" target="_blank" title="高性能MYSQL ------- 查询阻塞语句以及锁">
		<h4 class="text-truncate oneline">
				高性能<em>MYSQL</em> ------- 查询阻塞语句以及锁		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-20</span>
				<span class="read-num hover-hide">
					阅读数 
					3868</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012129607/article/details/78851920" target="_blank" title="高性能MYSQL ------- 查询阻塞语句以及锁">
				<span class="desc oneline">MYSQL服务器逻辑架构图连接/线程处理==》（解析器–&gt;查询缓存）===》优化器===》存储引擎高性能MYSQL——-锁的调试：服务器级别锁MYSQL使用的锁类型：表锁（显式:LOCKTABLE，隐...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012129607">来自：	<span class="blog_title"> 没有用户名的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/xiaolyuh123/article/details/62044794","strategy":"BlogCommendFromAutoMl2","index":"1"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xiaolyuh123/article/details/62044794","strategy":"BlogCommendFromAutoMl2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiaolyuh123/article/details/62044794" target="_blank" title="mysql kill process解决死锁">
		<h4 class="text-truncate oneline">
				<em>mysql</em> kill process解决死锁		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-14</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiaolyuh123/article/details/62044794" target="_blank" title="mysql kill process解决死锁">
				<span class="desc oneline">1、查看进程列表， 找到IDshowprocesslist;+--------+--------+--------------------+----------+---------+------+--...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiaolyuh123">来自：	<span class="blog_title"> xiaolyuh123的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/xb12369/article/details/44962285","strategy":"BlogCommendFromAutoMl2","index":"2"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xb12369/article/details/44962285","strategy":"BlogCommendFromAutoMl2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xb12369/article/details/44962285" target="_blank" title="解决MySQL中死进程（一个联合查询耗时32s）">
		<h4 class="text-truncate oneline">
				解决<em>MySQL</em>中死<em>进程</em>（一个联合查询耗时32s）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-09</span>
				<span class="read-num hover-hide">
					阅读数 
					3893</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xb12369/article/details/44962285" target="_blank" title="解决MySQL中死进程（一个联合查询耗时32s）">
				<span class="desc oneline">很奇怪的现象，一个联合查询（in）直接执行sql脚本的时候，NavicatPremium直接假死；检查是否有死进程：SELECT*FROMINFORMATION_SCHEMA.INNODB_TRX;可...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xb12369">来自：	<span class="blog_title"> 谢彬のCSDN专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_32074527/article/details/79347074","strategy":"BlogCommendFromAutoMl2","index":"3"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_32074527/article/details/79347074","strategy":"BlogCommendFromAutoMl2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_32074527/article/details/79347074" target="_blank" title="mysql数据库杀掉堵塞进程">
		<h4 class="text-truncate oneline">
				<em>mysql</em>数据库杀掉<em>堵塞</em><em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-22</span>
				<span class="read-num hover-hide">
					阅读数 
					6048</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_32074527/article/details/79347074" target="_blank" title="mysql数据库杀掉堵塞进程">
				<span class="desc oneline">mysql&amp;amp;gt;SHOWPROCESSLIST;查看进程;mysql&amp;amp;gt;KILLID;杀掉进程;这是杀掉单一进程,一个一个解决起来太麻烦;批量解决,导出到文件,在导入处理;1,m...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_32074527">来自：	<span class="blog_title"> qq_32074527的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-78","con":",,"}' data-track-click='{"mod":"kp_popu_59-78","con":",,"}' data-report-view='{"mod":"kp_popu_59-78","keyword":""}' data-report-click='{"mod":"kp_popu_59-78","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3491668",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/m0_37827567/article/details/82979767","strategy":"BlogCommendFromAutoMl2","index":"4"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/m0_37827567/article/details/82979767","strategy":"BlogCommendFromAutoMl2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/m0_37827567/article/details/82979767" target="_blank" title="mysql kill进程后出现killed死锁问题">
		<h4 class="text-truncate oneline">
				<em>mysql</em> kill<em>进程</em>后出现killed死锁问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-09</span>
				<span class="read-num hover-hide">
					阅读数 
					4653</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/m0_37827567/article/details/82979767" target="_blank" title="mysql kill进程后出现killed死锁问题">
				<span class="desc oneline">经常会出现这样的场景：有一张3亿的表，现在要对这张表进行删除1亿行，于是有人开始运行deletefromtablelimit100000000;毫无疑问这是一个愚蠢的删除方式，于是有人开始变更删除方式...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/m0_37827567">来自：	<span class="blog_title"> m0_37827567的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u013033845/article/details/84958085","strategy":"BlogCommendFromBaidu","index":"5"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u013033845/article/details/84958085","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u013033845/article/details/84958085" target="_blank" title="杀死MySQL内部sql进程">
		<h4 class="text-truncate oneline">
				<em>杀死</em><em>MySQL</em>内部sql<em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-11</span>
				<span class="read-num hover-hide">
					阅读数 
					602</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u013033845/article/details/84958085" target="_blank" title="杀死MySQL内部sql进程">
				<span class="desc oneline">今天折腾mysql数据库的时候，发现导入文件没有成功，当时也没有注意，直接重启了apache。但是新建的table进行任何访问：读写删，全部卡住。去google搜罗了一下，找到答案：mysql中该表的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u013033845">来自：	<span class="blog_title"> 益达的小作坊</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34247299/article/details/92150201","strategy":"BlogCommendFromBaidu","index":"6"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34247299/article/details/92150201","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34247299/article/details/92150201" target="_blank" title="mysql中kill掉所有锁表的进程">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中kill掉所有锁表的<em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-13</span>
				<span class="read-num hover-hide">
					阅读数 
					10</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34247299/article/details/92150201" target="_blank" title="mysql中kill掉所有锁表的进程">
				<span class="desc oneline">mysql&amp;gt;showprocesslist;出来哗啦啦好几屏幕的,没有一千也有几百条,查询语句把表锁住了,赶紧找出第一个Locked的thread_id,在mysql的shell里面执行.mys...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34247299">来自：	<span class="blog_title"> weixin_34247299的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/yuwenlanleng/article/details/84644295","strategy":"BlogCommendFromBaidu","index":"7"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/yuwenlanleng/article/details/84644295","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yuwenlanleng/article/details/84644295" target="_blank" title="查看mysql进程并杀掉mysql进程">
		<h4 class="text-truncate oneline">
				查看<em>mysql</em><em>进程</em>并杀掉<em>mysql</em><em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-30</span>
				<span class="read-num hover-hide">
					阅读数 
					1230</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yuwenlanleng/article/details/84644295" target="_blank" title="查看mysql进程并杀掉mysql进程">
				<span class="desc oneline">第一种: SHOWPROCESSLIST;1执行上述命令,可以看到下图: 然后找到对应的ID: KILL41515;1就OK了.第二种: 需要借助工具,Navicat.工具-&amp;amp;gt;服务器监控...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yuwenlanleng">来自：	<span class="blog_title"> yuwenlanleng的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_33528613/article/details/77743143","strategy":"BlogCommendFromBaidu","index":"8"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_33528613/article/details/77743143","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_33528613/article/details/77743143" target="_blank" title="Linux杀掉MySQL进程（关键词：Linux/MySQL/杀死进程/mysql/mysqld）">
		<h4 class="text-truncate oneline">
				Linux杀掉<em>MySQL</em><em>进程</em>（关键词：Linux/<em>MySQL</em>/<em>杀死</em><em>进程</em>/<em>mysql</em>/<em>mysql</em>d）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-31</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_33528613/article/details/77743143" target="_blank" title="Linux杀掉MySQL进程（关键词：Linux/MySQL/杀死进程/mysql/mysqld）">
				<span class="desc oneline">1.查看mysql程序对应的进程号使用命令：psps-e|grepmysql2.杀死mysql进程使用命令：sudokill-9mysql的进程号3.杀死mysqld进程使用命令：sudokillal...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_33528613">来自：	<span class="blog_title"> Henry1991back的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/A_Runner/article/details/78589170","strategy":"BlogCommendFromBaidu","index":"9"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/A_Runner/article/details/78589170","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/A_Runner/article/details/78589170" target="_blank" title="MYSQL查看进程和kill进程">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>查看<em>进程</em>和kill<em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-21</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/A_Runner/article/details/78589170" target="_blank" title="MYSQL查看进程和kill进程">
				<span class="desc oneline">“临深应在即，居高岂忘危”有时候我们在执行一条SQL语句时,或者更改表结构时,由于这张表的数据量巨大,,往往会在执行操作后就会卡住…然后这张表就会被锁住..这时,我们可以杀掉这个进程.这里有两种方法查...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/A_Runner">来自：	<span class="blog_title"> A_Runner的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/koven2049/article/details/83458371","strategy":"BlogCommendFromBaidu","index":"10"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/koven2049/article/details/83458371","strategy":"BlogCommendFromBaidu","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/koven2049/article/details/83458371" target="_blank" title="转载：mysql批量删除连接的方法">
		<h4 class="text-truncate oneline">
				转载：<em>mysql</em>批量删除连接的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-09</span>
				<span class="read-num hover-hide">
					阅读数 
					39</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/koven2049/article/details/83458371" target="_blank" title="转载：mysql批量删除连接的方法">
				<span class="desc oneline">如果大批量的操作能够通过一系列的select语句产生，那么理论上就能对这些结果批量处理。但是mysql并没用提供eval这样的对结果集进行分析操作的功能。所以只能现将select结果保存到临时文件中，...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/koven2049">来自：	<span class="blog_title"> 蓝色时分</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_31821675/article/details/80052088","strategy":"BlogCommendFromBaidu","index":"11"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_31821675/article/details/80052088","strategy":"BlogCommendFromBaidu","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_31821675/article/details/80052088" target="_blank" title="mysql 批量删除process">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 批量删除process		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-23</span>
				<span class="read-num hover-hide">
					阅读数 
					2009</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_31821675/article/details/80052088" target="_blank" title="mysql 批量删除process">
				<span class="desc oneline">mysql&amp;amp;gt;showprocesslist;查看数据库中所有进程mysql&amp;amp;gt;selectconcat('KILL',id,';')frominformation_schem...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_31821675">来自：	<span class="blog_title"> So What</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/a1007720052/article/details/79626371","strategy":"BlogCommendFromBaidu","index":"12"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/a1007720052/article/details/79626371","strategy":"BlogCommendFromBaidu","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/a1007720052/article/details/79626371" target="_blank" title="mysql 查询正在执行的进程">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 查询正在执行的<em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-20</span>
				<span class="read-num hover-hide">
					阅读数 
					3200</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/a1007720052/article/details/79626371" target="_blank" title="mysql 查询正在执行的进程">
				<span class="desc oneline">mysql查询正在执行的进程命令：showprocesslist每一列的含义和用途：第一列 id，不用说了吧，一个标识，你要kill一个语句的时候很有用。第二列 user列，显示单前用户，如果不是ro...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/a1007720052">来自：	<span class="blog_title"> 陈新明博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/YABIGNSHI/article/details/46562985","strategy":"BlogCommendFromBaidu","index":"13"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/YABIGNSHI/article/details/46562985","strategy":"BlogCommendFromBaidu","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/YABIGNSHI/article/details/46562985" target="_blank" title="MySql检测阻塞,锁等待sql">
		<h4 class="text-truncate oneline">
				<em>MySql</em>检测阻塞,锁等待sql		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-19</span>
				<span class="read-num hover-hide">
					阅读数 
					6205</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/YABIGNSHI/article/details/46562985" target="_blank" title="MySql检测阻塞,锁等待sql">
				<span class="desc oneline">SELECT      p2.`HOST`被阻塞方host,p2.`USER`被阻塞方用户,r.trx_id被阻塞方事务id,      r.trx_mysql_thread_id被阻塞方线程号,  ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/YABIGNSHI">来自：	<span class="blog_title"> 雅冰石的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qingsong3333/article/details/77170755","strategy":"BlogCommendFromBaidu","index":"14"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qingsong3333/article/details/77170755","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qingsong3333/article/details/77170755" target="_blank" title="每日MySQL之022：使用SHOW PROCESSLIST查看应用与使用KILL杀掉应用">
		<h4 class="text-truncate oneline">
				每日<em>MySQL</em>之022：使用SHOW PROCESSLIST查看应用与使用KILL杀掉应用		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-14</span>
				<span class="read-num hover-hide">
					阅读数 
					1879</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qingsong3333/article/details/77170755" target="_blank" title="每日MySQL之022：使用SHOW PROCESSLIST查看应用与使用KILL杀掉应用">
				<span class="desc oneline">1.查看应用MySQL中，每一个连接进来，都会对应一个独立的线程。可以使用mysqladmin命令的processlist参数来查看所有应用，或者使用SHOWPROCESSLIST命令；要查看当前的连...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qingsong3333">来自：	<span class="blog_title"> 匿_名_用_户的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/lixingfu1009/article/details/81166693","strategy":"BlogCommendFromAutoMl2","index":"15"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lixingfu1009/article/details/81166693","strategy":"BlogCommendFromAutoMl2","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lixingfu1009/article/details/81166693" target="_blank" title="Mysql批量杀死线程">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>批量<em>杀死</em>线程		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-23</span>
				<span class="read-num hover-hide">
					阅读数 
					1267</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lixingfu1009/article/details/81166693" target="_blank" title="Mysql批量杀死线程">
				<span class="desc oneline">一、场景描述在mysql的管理维护工作中，有时候会出现锁表的情况，表现为一个线程占用mysql进程，其他线程只能等待，可能的原因比较多，之前遇到的两种情况是，数据库操作的代码逻辑不合理（对数据库操作没...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lixingfu1009">来自：	<span class="blog_title"> 思绪飞扬的大白的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33836223/article/details/85985460","strategy":"BlogCommendFromAutoMl2","index":"16"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33836223/article/details/85985460","strategy":"BlogCommendFromAutoMl2","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33836223/article/details/85985460" target="_blank" title="MySQL Innodb如何找出阻塞事务源头SQL">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> Innodb如何找出阻塞事务源头SQL		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-26</span>
				<span class="read-num hover-hide">
					阅读数 
					6</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33836223/article/details/85985460" target="_blank" title="MySQL Innodb如何找出阻塞事务源头SQL">
				<span class="desc oneline"> 在MySQL数据库中出现了阻塞问题，如何快速查找定位问题根源？在实验开始前，我们先梳理一下有什么工具或命令查看MySQL的阻塞，另外，我们也要一一对比其优劣，因为有些命令可能在实际环境下可能并不适用...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33836223">来自：	<span class="blog_title"> weixin_33836223的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_42213615/article/details/81163917","strategy":"BlogCommendFromAutoMl2","index":"17"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_42213615/article/details/81163917","strategy":"BlogCommendFromAutoMl2","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_42213615/article/details/81163917" target="_blank" title="用INSERT DELAYED解决MySQL堵塞问题">
		<h4 class="text-truncate oneline">
				用INSERT DELAYED解决<em>MySQL</em><em>堵塞</em>问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-23</span>
				<span class="read-num hover-hide">
					阅读数 
					43</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_42213615/article/details/81163917" target="_blank" title="用INSERT DELAYED解决MySQL堵塞问题">
				<span class="desc oneline">由于对MySQL的并发插入数据能力没有一个很好的评估，因此在些多进程并发程序时，忽略了MySQL的堵塞问题以至程序时不时因为MySQL的堵塞，导致子进程一直在等待MySQL释放堵塞，完成INSERT ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_42213615">来自：	<span class="blog_title"> qq_42213615的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/scdnlin/article/details/46970317","strategy":"BlogCommendFromAutoMl2","index":"18"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/scdnlin/article/details/46970317","strategy":"BlogCommendFromAutoMl2","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/scdnlin/article/details/46970317" target="_blank" title="杀 mysql的进程">
		<h4 class="text-truncate oneline">
				杀 <em>mysql</em>的<em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-20</span>
				<span class="read-num hover-hide">
					阅读数 
					229</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/scdnlin/article/details/46970317" target="_blank" title="杀 mysql的进程">
				<span class="desc oneline">杀mysql进程showprocesslistkillxxxxxx表示sql进程id</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/scdnlin">来自：	<span class="blog_title"> scdnlin的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-556","con":",,"}' data-track-click='{"mod":"kp_popu_62-556","con":",,"}' data-report-view='{"mod":"kp_popu_62-556","keyword":""}' data-report-click='{"mod":"kp_popu_62-556","keyword":""}'><div id="three_ad18" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad18",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/shinyv2062/article/details/51063074","strategy":"BlogCommendFromAutoMl2","index":"19"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/shinyv2062/article/details/51063074","strategy":"BlogCommendFromAutoMl2","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/shinyv2062/article/details/51063074" target="_blank" title="查看一个进程所使用的文件句柄数">
		<h4 class="text-truncate oneline">
				查看一个<em>进程</em>所使用的文件句柄数		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-05</span>
				<span class="read-num hover-hide">
					阅读数 
					1135</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/shinyv2062/article/details/51063074" target="_blank" title="查看一个进程所使用的文件句柄数">
				<span class="desc oneline">1ps-ef|grepmysqlroot31711018:55?00:00:00/bin/sh/usr/bin/mysqld_safe--datadir=/var/lib/mysql--pid-fil...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/shinyv2062">来自：	<span class="blog_title"> shinyv2062的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/smilehung/article/details/54424724","strategy":"BlogCommendFromBaidu","index":"20"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/smilehung/article/details/54424724","strategy":"BlogCommendFromBaidu","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/smilehung/article/details/54424724" target="_blank" title="杀掉mysql进程之后，我通宵了一整个晚上">
		<h4 class="text-truncate oneline">
				杀掉<em>mysql</em><em>进程</em>之后，我通宵了一整个晚上		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-14</span>
				<span class="read-num hover-hide">
					阅读数 
					2533</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/smilehung/article/details/54424724" target="_blank" title="杀掉mysql进程之后，我通宵了一整个晚上">
				<span class="desc oneline">mysql导入数据的时候，导到一半，卡住不动了，Ctr+C也跳不出来，只好把mysql的进程都杀掉。把mysql重启一下，好嘛，这下出大问题了。重启不了了，报socket找不到：error:‘Can’...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/smilehung">来自：	<span class="blog_title"> 蟠龙有悔的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/liangguangchuan/article/details/51207746","strategy":"BlogCommendFromBaidu","index":"21"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/liangguangchuan/article/details/51207746","strategy":"BlogCommendFromBaidu","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/liangguangchuan/article/details/51207746" target="_blank" title="如何杀掉Mysql内部进程">
		<h4 class="text-truncate oneline">
				如何杀掉<em>Mysql</em>内部<em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-21</span>
				<span class="read-num hover-hide">
					阅读数 
					1224</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/liangguangchuan/article/details/51207746" target="_blank" title="如何杀掉Mysql内部进程">
				<span class="desc oneline">个人是用来杀掉卡死的进程。1、首先用命令showprocesslist，显示正在运行的进程。2、用kill命令id，杀掉卡死的进程。命令id可以从showprocesslist的result中第一列查...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/liangguangchuan">来自：	<span class="blog_title"> 小码农的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"http://ask.csdn.net/questions/354598","strategy":"BlogCommendFromBaidu","index":"22"}' data-report-click='{"mod":"popu_387","dest":"http://ask.csdn.net/questions/354598","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<a href="http://ask.csdn.net/questions/354598" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em>会话监控是否有阻塞的sql语句		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">12-27</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">-</span>
							<span class="type-show type-show-ask">问答</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/du_23tiyanwang/article/details/80932286","strategy":"BlogCommendFromBaidu","index":"23"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/du_23tiyanwang/article/details/80932286","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/du_23tiyanwang/article/details/80932286" target="_blank" title="Mysql 5.7阻塞了的处理方法">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> 5.7阻塞了的处理方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-05</span>
				<span class="read-num hover-hide">
					阅读数 
					1103</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/du_23tiyanwang/article/details/80932286" target="_blank" title="Mysql 5.7阻塞了的处理方法">
				<span class="desc oneline">Mysql阻塞出现错误了怎么处理呢？ERROR1205(HY000):Lockwaittimeoutexceeded;tryrestartingtransactionMysql5.7线程阻塞了的解决办...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/du_23tiyanwang">来自：	<span class="blog_title"> du_23tiyanwang的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-555","con":",,"}' data-track-click='{"mod":"kp_popu_63-555","con":",,"}' data-report-view='{"mod":"kp_popu_63-555","keyword":""}' data-report-click='{"mod":"kp_popu_63-555","keyword":""}'><div id="three_ad23" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad23",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_387","dest":"https://download.csdn.net/download/kun111/10036971","strategy":"BlogCommendFromBaidu","index":"24"}' data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/kun111/10036971","strategy":"BlogCommendFromBaidu","index":"24"}'>
		<a href="https://download.csdn.net/download/kun111/10036971" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						查找阻塞<em>进程</em>sql					</h4>
					<span class="data float-right">10-23</span>
				</div>
				<div class="desc oneline">
						查找阻塞进程sql的方法,查找阻塞进程sql的方法,减少死锁				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/xfblue2dreamfy/article/details/6577853","strategy":"BlogCommendFromBaidu","index":"25"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xfblue2dreamfy/article/details/6577853","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xfblue2dreamfy/article/details/6577853" target="_blank" title="强制干掉-杀数据库进程">
		<h4 class="text-truncate oneline">
				强制干掉-杀数据库<em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-30</span>
				<span class="read-num hover-hide">
					阅读数 
					5969</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xfblue2dreamfy/article/details/6577853" target="_blank" title="强制干掉-杀数据库进程">
				<span class="desc oneline">有时候Oralce中一些进程会由于各种各样的原因hang住，我们可以使用altersystemkillsession杀掉僵死的进程。有些ORACLE中的进程被杀掉后，状态被置为&quot;killed&quot;，但是占...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xfblue2dreamfy">来自：	<span class="blog_title"> 您好：nevanzax</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/HW_LiBo/article/details/39080809","strategy":"BlogCommendFromBaidu","index":"26"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/HW_LiBo/article/details/39080809","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/HW_LiBo/article/details/39080809" target="_blank" title="MySQL锁阻塞分析">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>锁阻塞分析		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-05</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/HW_LiBo/article/details/39080809" target="_blank" title="MySQL锁阻塞分析">
				<span class="desc oneline">日常维护中，经常会碰到线程被阻塞，导致数据库响应非常慢，下面就看看如何获取是哪个线程导致了阻塞的。1.环境说明RHEL6.4x86_64+MySQL5.6.19事务隔离级别：RR2.测试过程3.查看锁...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/HW_LiBo">来自：	<span class="blog_title"> BOSCO 蜻蜓点水，一点一滴</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/cleanfield/article/details/7265617","strategy":"BlogCommendFromBaidu","index":"27"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/cleanfield/article/details/7265617","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/cleanfield/article/details/7265617" target="_blank" title="追踪mysql阻塞的问题">
		<h4 class="text-truncate oneline">
				追踪<em>mysql</em>阻塞的问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-16</span>
				<span class="read-num hover-hide">
					阅读数 
					4354</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/cleanfield/article/details/7265617" target="_blank" title="追踪mysql阻塞的问题">
				<span class="desc oneline">这两天总是会出现fcgi程序挂住，不能继续处理的问题，通过日志发现是在mysql的execute接口出问题，strace进程看到 strace-p3497Process3497attached-int...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/cleanfield">来自：	<span class="blog_title"> cleanfield的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/zkaipmoo/article/details/38733995","strategy":"BlogCommendFromBaidu","index":"28"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zkaipmoo/article/details/38733995","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zkaipmoo/article/details/38733995" target="_blank" title="批量kill mysql进程">
		<h4 class="text-truncate oneline">
				批量kill <em>mysql</em><em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-21</span>
				<span class="read-num hover-hide">
					阅读数 
					3484</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zkaipmoo/article/details/38733995" target="_blank" title="批量kill mysql进程">
				<span class="desc oneline">mysql服务器负载太大，需要杀掉很多查询的进程</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zkaipmoo">来自：	<span class="blog_title"> 企鹅漫步</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-1060","con":",,"}' data-track-click='{"mod":"kp_popu_64-1060","con":",,"}' data-report-view='{"mod":"kp_popu_64-1060","keyword":""}' data-report-click='{"mod":"kp_popu_64-1060","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/235?positionId=64&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/large2boy/article/details/10297207","strategy":"BlogCommendFromBaidu","index":"29"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/large2boy/article/details/10297207","strategy":"BlogCommendFromBaidu","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/large2boy/article/details/10297207" target="_blank" title="MySQL最大连接数设置">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>最大连接数设置		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-25</span>
				<span class="read-num hover-hide">
					阅读数 
					578</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/large2boy/article/details/10297207" target="_blank" title="MySQL最大连接数设置">
				<span class="desc oneline">在使用MySQL数据库的时候，经常会遇到这么一个问题，就是“CannotconnecttoMySQLserver. Toomanyconnections”-mysql1040错误，这是因为访问MySQ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/large2boy">来自：	<span class="blog_title"> large2boy的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/fasttime/article/details/83150524","strategy":"BlogCommendFromBaidu","index":"30"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/fasttime/article/details/83150524","strategy":"BlogCommendFromBaidu","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/fasttime/article/details/83150524" target="_blank" title="mac mysql 进程 kill 杀不掉">
		<h4 class="text-truncate oneline">
				mac <em>mysql</em> <em>进程</em> kill 杀不掉		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-18</span>
				<span class="read-num hover-hide">
					阅读数 
					1821</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/fasttime/article/details/83150524" target="_blank" title="mac mysql 进程 kill 杀不掉">
				<span class="desc oneline">现象：macmysql进程kill杀不掉,杀了立马就有新的进程ID，说明有其它进程在守护采用ps-ef|grepmysql得知，确实有系统进程在守护,想起以前安装时，系统设置有mysql，采用系统设置...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/fasttime">来自：	<span class="blog_title"> fasttime的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_24613517/article/details/80690213","strategy":"BlogCommendFromBaidu","index":"31"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_24613517/article/details/80690213","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_24613517/article/details/80690213" target="_blank" title="mysql使用kill命令解决死锁问题 杀死某条正在执行的sql语句">
		<h4 class="text-truncate oneline">
				<em>mysql</em>使用kill命令解决死锁问题 <em>杀死</em>某条正在执行的sql语句		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-14</span>
				<span class="read-num hover-hide">
					阅读数 
					2199</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_24613517/article/details/80690213" target="_blank" title="mysql使用kill命令解决死锁问题 杀死某条正在执行的sql语句">
				<span class="desc oneline">在使用mysql运行某些语句时，会因数据量太大而导致死锁，没有反映。这个时候，就需要kill掉某个正在消耗资源的query语句即可，　KILL命令的语法格式如下：KILL[CONNECTION|QUE...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_24613517">来自：	<span class="blog_title"> 番石榴</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/wzqzhq/article/details/73733173","strategy":"BlogCommendFromBaidu","index":"32"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wzqzhq/article/details/73733173","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wzqzhq/article/details/73733173" target="_blank" title="mysql使用kill无法杀死进程">
		<h4 class="text-truncate oneline">
				<em>mysql</em>使用kill无法<em>杀死</em><em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-26</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wzqzhq/article/details/73733173" target="_blank" title="mysql使用kill无法杀死进程">
				<span class="desc oneline">在公司一次系统关机后，重启机器，系统启动了自带的mysql进程，想要启动自己所需配置文件的mysql，就要杀掉默认的mysql。使用kill-9+pid号，mysql不但没被杀掉，而且换了一个pid号...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wzqzhq">来自：	<span class="blog_title"> wzq的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/zhangdaohong/article/details/80307807","strategy":"BlogCommendFromBaidu","index":"33"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhangdaohong/article/details/80307807","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhangdaohong/article/details/80307807" target="_blank" title="mysql查看被锁住的表，正在进行的进程，已经杀掉进程的方法">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查看被锁住的表，正在进行的<em>进程</em>，已经杀掉<em>进程</em>的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-25</span>
				<span class="read-num hover-hide">
					阅读数 
					989</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhangdaohong/article/details/80307807" target="_blank" title="mysql查看被锁住的表，正在进行的进程，已经杀掉进程的方法">
				<span class="desc oneline">https://www.cnblogs.com/azhqiang/p/5970067.html//查看所有进程showprocesslist;//查询是否锁表showOPENTABLESwhereIn...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhangdaohong">来自：	<span class="blog_title"> zhangdaohong的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-84","con":",,"}' data-track-click='{"mod":"kp_popu_65-84","con":",,"}' data-report-view='{"mod":"kp_popu_65-84","keyword":""}' data-report-click='{"mod":"kp_popu_65-84","keyword":""}'><div id="three_ad33" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad33",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/akemt/article/details/52637987","strategy":"BlogCommendFromBaidu","index":"34"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/akemt/article/details/52637987","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/akemt/article/details/52637987" target="_blank" title="mysql查看sql进程">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查看sql<em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-23</span>
				<span class="read-num hover-hide">
					阅读数 
					3621</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/akemt/article/details/52637987" target="_blank" title="mysql查看sql进程">
				<span class="desc oneline">1.查看数据库中所有sql进程SELECT*FROMinformation_schema.PROCESSLISTWHEREinfoISNOTNULLORDERBYTIMEdesc,state,INFO...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/akemt">来自：	<span class="blog_title"> akemt的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/angle_sun/article/details/52496635","strategy":"BlogCommendFromBaidu","index":"35"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/angle_sun/article/details/52496635","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/angle_sun/article/details/52496635" target="_blank" title="解决liunx进程杀不死的问题">
		<h4 class="text-truncate oneline">
				解决liunx<em>进程</em>杀不死的问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-10</span>
				<span class="read-num hover-hide">
					阅读数 
					5259</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/angle_sun/article/details/52496635" target="_blank" title="解决liunx进程杀不死的问题">
				<span class="desc oneline">liunx中有时候通过命令ps-ef|grep进程名，查看进程pid号，杀进程的时候会杀不死，是因为可能杀的是子进程而不是父进程，整个进程树没有死。针对这种情况，我苦寻到一个命令，来解决这种问题。查看...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/angle_sun">来自：	<span class="blog_title"> angle_sun的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/aeolus_pu/article/details/54668087","strategy":"BlogCommendFromBaidu","index":"36"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/aeolus_pu/article/details/54668087","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/aeolus_pu/article/details/54668087" target="_blank" title="线程与进程---mysql">
		<h4 class="text-truncate oneline">
				线程与<em>进程</em>---<em>mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-22</span>
				<span class="read-num hover-hide">
					阅读数 
					1205</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/aeolus_pu/article/details/54668087" target="_blank" title="线程与进程---mysql">
				<span class="desc oneline">进程(process):进程是一组有自己的内存和执行路径的计算机指令；      线程（thread):线程虽然是一组计算机指令，但线程都执行在一个宿主的执行路径里，没有自己的内存。（线程也被有些人称...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/aeolus_pu">来自：	<span class="blog_title"> aeoluspu的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/G_Youda/article/details/79207627","strategy":"BlogCommendFromBaidu","index":"37"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/G_Youda/article/details/79207627","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/G_Youda/article/details/79207627" target="_blank" title="MySQL数据库操作卡死问题">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>数据库操作卡死问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-30</span>
				<span class="read-num hover-hide">
					阅读数 
					1682</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/G_Youda/article/details/79207627" target="_blank" title="MySQL数据库操作卡死问题">
				<span class="desc oneline">在MySQL数据库操作的时候难免会遇到卡死的问题，下面给出一个常用的小技巧：1、showfullprocesslist;  列出当前的操作process，一般会看到很多waiting的process，...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/G_Youda">来自：	<span class="blog_title"> Youda的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/xiangliangyu2008/article/details/16825397","strategy":"BlogCommendFromBaidu","index":"38"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xiangliangyu2008/article/details/16825397","strategy":"BlogCommendFromBaidu","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiangliangyu2008/article/details/16825397" target="_blank" title="Mysql进程查看 show processlist(kill ID)">
		<h4 class="text-truncate oneline">
				<em>Mysql</em><em>进程</em>查看 show processlist(kill ID)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-19</span>
				<span class="read-num hover-hide">
					阅读数 
					8399</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiangliangyu2008/article/details/16825397" target="_blank" title="Mysql进程查看 show processlist(kill ID)">
				<span class="desc oneline">Mysql进程查看showprocesslist;通过查看Mysql进程来分析行锁表锁：showprocesslistSHOWPROCESSLIST显示哪些线程正在运行。    如果您有SUPER权限...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiangliangyu2008">来自：	<span class="blog_title"> 良玉的博客 http://blog.uouo123.com/，欢迎收录</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/cfyme/article/details/84712283","strategy":"BlogCommendFromBaidu","index":"39"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/cfyme/article/details/84712283","strategy":"BlogCommendFromBaidu","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/cfyme/article/details/84712283" target="_blank" title="查询mysql 锁表">
		<h4 class="text-truncate oneline">
				查询<em>mysql</em> 锁表		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-15</span>
				<span class="read-num hover-hide">
					阅读数 
					55</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/cfyme/article/details/84712283" target="_blank" title="查询mysql 锁表">
				<span class="desc oneline">查询mysql哪些表正在被锁状态 showOPENTABLESwhereIn_use&amp;amp;gt;0; showprocesslist;showfullprocesslist; killid //杀...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/cfyme">来自：	<span class="blog_title"> 会当凌绝顶 一览众山小</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_35334804/article/details/80205981","strategy":"BlogCommendFromBaidu","index":"40"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_35334804/article/details/80205981","strategy":"BlogCommendFromBaidu","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_35334804/article/details/80205981" target="_blank" title="mysql 杀死进程">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>杀死</em><em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-05</span>
				<span class="read-num hover-hide">
					阅读数 
					4211</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_35334804/article/details/80205981" target="_blank" title="mysql 杀死进程">
				<span class="desc oneline">查询进程：select*frominformation_schema.innodb_trx;进程号：trx_mysql_thread_id如：kill160836;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_35334804">来自：	<span class="blog_title"> qq_35334804的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/anzhen0429/article/details/78210929","strategy":"BlogCommendFromBaidu","index":"41"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/anzhen0429/article/details/78210929","strategy":"BlogCommendFromBaidu","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/anzhen0429/article/details/78210929" target="_blank" title="mysql too many connections问题，kill掉所有锁表进程">
		<h4 class="text-truncate oneline">
				<em>mysql</em> too many connections问题，kill掉所有锁表<em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-12</span>
				<span class="read-num hover-hide">
					阅读数 
					1035</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/anzhen0429/article/details/78210929" target="_blank" title="mysql too many connections问题，kill掉所有锁表进程">
				<span class="desc oneline">说明：因为线上mysql实例太多，也就经常会遇到Toomanyconnections的问题。出现这种问题的时候业务已经出现问题。此时最重要的还是先恢复业务。这里可以先获取showinnodbstatu...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/anzhen0429">来自：	<span class="blog_title"> anzhen0429的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/200049269","strategy":"BlogCommendFromBaidu","index":"42"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/200049269","strategy":"BlogCommendFromBaidu","index":"42"}'>
	<a href="https://bbs.csdn.net/topics/200049269" target="_blank">
		<h4 class="text-truncate oneline">
				晕了，<em>mysql</em> 居然kill不掉，请问有人知道吗？		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">01-30</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">以前从来没遇到过这种问题，虽然有相关现象（参见http://topic.csdn.net/u/20080123/15/47f2a905-36dd-45bf-a913-98b3018fd9d2.html</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/buster2014/article/details/51035768","strategy":"BlogCommendFromBaidu","index":"43"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/buster2014/article/details/51035768","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/buster2014/article/details/51035768" target="_blank" title="mysql使用kill命令解决死锁问题,杀死某条正在执行的sql语句">
		<h4 class="text-truncate oneline">
				<em>mysql</em>使用kill命令解决死锁问题,<em>杀死</em>某条正在执行的sql语句		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-01</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/buster2014/article/details/51035768" target="_blank" title="mysql使用kill命令解决死锁问题,杀死某条正在执行的sql语句">
				<span class="desc oneline">http://www.360sdn.com/mysql/2013/0815/823.html在使用mysql运行某些语句时，会因数据量太大而导致死锁，没有反映。这个时候，就需要kill掉某个正在消耗资...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/buster2014">来自：	<span class="blog_title"> Thinking</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-653","con":",,"}' data-track-click='{"mod":"kp_popu_67-653","con":",,"}' data-report-view='{"mod":"kp_popu_67-653","keyword":""}' data-report-click='{"mod":"kp_popu_67-653","keyword":""}'><div id="three_ad43" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : '9gAEHz',
                placeholderId: "three_ad43",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 12,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/mygodhome/article/details/25139357","strategy":"BlogCommendFromBaidu","index":"44"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/mygodhome/article/details/25139357","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/mygodhome/article/details/25139357" target="_blank" title="kill -9 can't kill">
		<h4 class="text-truncate oneline">
				kill -9 can't kill		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-06</span>
				<span class="read-num hover-hide">
					阅读数 
					493</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/mygodhome/article/details/25139357" target="_blank" title="kill -9 can't kill">
				<span class="desc oneline">kill-9发送SIGKILL信号将其终止，但是以下两种情况不起作用：a、该进程处于&quot;Zombie&quot;状态（使用ps命令返回defunct的进程）。此时进程已经释放所有资源，但还未得到其父进程的确认。&quot;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/mygodhome">来自：	<span class="blog_title"> mygodhome的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/jamesge2010/article/details/53749706","strategy":"BlogCommendFromBaidu","index":"45"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jamesge2010/article/details/53749706","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jamesge2010/article/details/53749706" target="_blank" title="mysql查询正在执行的进程">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查询正在执行的<em>进程</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-19</span>
				<span class="read-num hover-hide">
					阅读数 
					596</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jamesge2010/article/details/53749706" target="_blank" title="mysql查询正在执行的进程">
				<span class="desc oneline">查看mysql进程有两种方法1.进入mysql/bin目录下输入mysqladminprocesslist;2.启动mysql，输入showprocesslist;如果有SUPER权限，则可以看到全部...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jamesge2010">来自：	<span class="blog_title"> Bingo_Ge的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_387","dest":"https://download.csdn.net/download/two_water/9596051","strategy":"BlogCommendFromBaidu","index":"46"}' data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/two_water/9596051","strategy":"BlogCommendFromBaidu","index":"46"}'>
		<a href="https://download.csdn.net/download/two_water/9596051" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						杀不死的<em>进程</em>					</h4>
					<span class="data float-right">08-05</span>
				</div>
				<div class="desc oneline">
						杀不死的进程				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/hj5419/article/details/80236222","strategy":"BlogCommendFromBaidu","index":"47"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hj5419/article/details/80236222","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hj5419/article/details/80236222" target="_blank" title="【mysql】#进阶#mysql的参数、状态、进程查看">
		<h4 class="text-truncate oneline">
				【<em>mysql</em>】#进阶#<em>mysql</em>的参数、状态、<em>进程</em>查看		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-08</span>
				<span class="read-num hover-hide">
					阅读数 
					568</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hj5419/article/details/80236222" target="_blank" title="【mysql】#进阶#mysql的参数、状态、进程查看">
				<span class="desc oneline">参数查看showVARIABLES查看所有配置参数showVARIABLESlike'%port%'查看具体某些参数状态查看showSTATUS查看所有状态showSTATUSlike'%Com_in...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hj5419">来自：	<span class="blog_title"> JoinIn,</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/alexdamiao/article/details/51498684","strategy":"BlogCommendFromBaidu","index":"48"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/alexdamiao/article/details/51498684","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/alexdamiao/article/details/51498684" target="_blank" title="MySql在Linux的启动方式">
		<h4 class="text-truncate oneline">
				<em>MySql</em>在Linux的启动方式		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-25</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/alexdamiao/article/details/51498684" target="_blank" title="MySql在Linux的启动方式">
				<span class="desc oneline">在Linux系统下，MySQL服务器通常有四种启动方式：mysqld守护进程启动，mysqld_safe启动，mysql.server启动，mysqld_multi多实例启动。1、mysqld守护进程...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/alexdamiao">来自：	<span class="blog_title"> alex大喵的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/ZhiyouWu/article/details/53837897","strategy":"BlogCommendFromBaidu","index":"49"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ZhiyouWu/article/details/53837897","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ZhiyouWu/article/details/53837897" target="_blank" title="杀死Mysql所占用的连接">
		<h4 class="text-truncate oneline">
				<em>杀死</em><em>Mysql</em>所占用的连接		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-23</span>
				<span class="read-num hover-hide">
					阅读数 
					6534</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ZhiyouWu/article/details/53837897" target="_blank" title="杀死Mysql所占用的连接">
				<span class="desc oneline">这两天，公司的mysql数据库总是报连接数超过最大的连接数了，而我们公司的开发人员没有那么多的，那么问题来了，这个问题一爆出来，导致开发进度受限，运维查了下，发现是我的ip竟然占用了70个连接，最大的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ZhiyouWu">来自：	<span class="blog_title"> ZhiyouWu的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/NtzaYgwsNjEtZWR1.html" target="_blank">
                        学习java进程</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/NtzaMg2sODUtZWR1.html" target="_blank">
                        java的学习进程</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/shinyv2062">
              <img src="https://avatar.csdn.net/6/F/6/3_shinyv2062.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/4.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/shinyv2062"  class="" id="uid">shinyv2062</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="25">
                        <dt><a href="https://blog.csdn.net/shinyv2062?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/shinyv2062?t=1"><span class="count">25</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="0">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">0</span></dd>
        </dl>
        <dl class="text-center" title="1">
            <dt>喜欢</dt>
            <dd><span class="count">1</span></dd>
        </dl>
        <dl class="text-center" title="1">
            <dt>评论</dt>
            <dd><span class="count">1</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="2级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-2"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="27723">
                2万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="499">
                499            </dd>
        </dl>
        <dl title="146603">
            <dt>排名：</dt>
            <dd>14万+</dd>
        </dl>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/shinyv2062">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-76","con":",,"}' data-track-click='{"mod":"kp_popu_56-76","con":",,"}' data-report-view='{"mod":"kp_popu_56-76","keyword":""}' data-report-click='{"mod":"kp_popu_56-76","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3032528",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/shinyv2062/article/details/79225065" target="_blank" >
                                        mysqlbinlog                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/shinyv2062/article/details/79225043" target="_blank" >
                                        mysql 查看所有表的数据行数                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/shinyv2062/article/details/79221468" target="_blank" >
                                        mysql show processlist参数 说明                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/shinyv2062/article/details/79221449" target="_blank" >
                                        MYSQL 创建数据库                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/shinyv2062/article/details/79221403" target="_blank" >
                                        批量删除mysql线程                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/shinyv2062/article/category/6162292">
                    <span class="title oneline">奇奇怪怪的问题</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/shinyv2062/article/category/6163213">
                    <span class="title oneline">写一点也许会进步一点</span>
                    <span class="count float-right">15篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/shinyv2062/article/category/6173077">
                    <span class="title oneline">一本书-看一点写一点</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/shinyv2062/article/category/7254882">
                    <span class="title oneline">linux</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/shinyv2062/article/category/7436463">
                    <span class="title oneline">mysql</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                    </ul>
    </div>
    </div>
<div id="asideArchive" class="aside-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/shinyv2062/article/month/2018/02">
                    2018年2月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/shinyv2062/article/month/2018/01">
                    2018年1月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/shinyv2062/article/month/2017/10">
                    2017年10月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/shinyv2062/article/month/2016/05">
                    2016年5月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/shinyv2062/article/month/2016/04">
                    2016年4月                    <span class="count float-right">14篇</span>
                </a>
            </li>
                    </ul>
    </div>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/shinyv2062/article/details/51261132" >
                                                mysql杀死堵塞进程                    </a>
					<p class="read">阅读数 <span>14973</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/shinyv2062/article/details/51065401" >
                                                awk认真的总结（入门）-AWK程序设计语言                    </a>
					<p class="read">阅读数 <span>1382</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/shinyv2062/article/details/79225043" >
                                                mysql 查看所有表的数据行数                    </a>
					<p class="read">阅读数 <span>1372</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/shinyv2062/article/details/51192547" >
                                                PHP添加新模块                    </a>
					<p class="read">阅读数 <span>1233</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/shinyv2062/article/details/51043075" >
                                                解决应为tomcat日志造成磁盘空间不足                    </a>
					<p class="read">阅读数 <span>1163</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/shinyv2062/article/details/51261132#comments">mysql杀死堵塞进程</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/sweetsweet0987" class="user-name" target="_blank">sweetsweet0987：</a>我草，我以为要用一个多么牛逼的办法解决呢。。。。。。。。。。                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-77","con":",,"}' data-track-click='{"mod":"kp_popu_57-77","con":",,"}' data-report-view='{"mod":"kp_popu_57-77","keyword":""}' data-report-click='{"mod":"kp_popu_57-77","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3163270",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box ">
			<button class=" low-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">0</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments long-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
						1				</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/shinyv2062/article/details/51260822" title="使用shell脚本显示出当前路径或者去掉目录路径">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/shinyv2062/article/details/51277054" title="修改表结构中的一个值">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/shinyv2062/article/details/51260822" title="使用shell脚本显示出当前路径或者去掉目录路径">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/shinyv2062/article/details/51277054" title="修改表结构中的一个值">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 12;
    var articleId = "51261132";
    var commentscount = 1;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/shinyv2062/article/details/51261132";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "mysql杀死堵塞进程 - shinyv2062的博客";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql","\u6740\u6b7b","\u5835\u585e","\u8fdb\u7a0b"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '本文为博主原创文章，未经博主允许不得转载。';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
